SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 388191 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 388191 [ RunTime:0.001641s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (371645,404344,369461,413287,885797,304350,966737,824290,307189,745010,669550,319102,589638,263865,706836,621398,2701,705191,665300,452929,1002180,320030,122355,251176,42427,235067,937652,132631,525912,664317,501488,362538,161956,487133,829132,454577,658858,107042,184376,393492,906640,210805,718190,233565,553523,483053,325409,390451,399614,332521,121124,208466,857251,894525,11253,904474,244180,393227,563710,580148) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001092s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 388191 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 388191 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000546s ]