SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001238s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 511109 LIMIT 1 [ RunTime:0.000308s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 511109 [ RunTime:0.002263s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (801852,344780,334759,545137,765091,528565,124267,388099,551540,901306,523371,538759,52655,182772,873551,207994,938864,571501,464527,65986,1012798,360463,813193,179754,337994,225857,57375,182301,973579,60257,1778,1017127,391276,735928,19426,807535,983041,814504,705380,1039169,44725,108770,758661,288959,791405,505443,69476,90384,859086,665794,983225,411901,135241,955993,243253,785214,218214,1031034,815350,115558) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001061s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 511109 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 511109 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000544s ]