SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002764s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402529 LIMIT 1 [ RunTime:0.000528s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402529 [ RunTime:0.004133s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (402781,430497,40423,527281,1024164,232156,762170,666554,300718,221368,698111,300691,529172,939424,850769,374016,948409,597770,333358,808422,1006356,604900,411453,679288,909421,528413,954899,178159,239705,209069,597120,169270,564829,540926,807258,209412,12212,175986,825988,155809,13642,729940,378225,1009640,897023,32432,976591,322138,753738,893769,264331,890480,910426,649277,512507,697958,73719,168872,117237,146196) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001976s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402529 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000550s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402529 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002347s ]