SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001291s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 781880 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 781880 [ RunTime:0.002233s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (596875,50852,751894,205445,423318,252294,1015969,878251,901031,960533,914926,594855,639692,433028,36722,288139,16049,1019649,31179,970733,464424,785316,518535,461613,543690,518432,699032,838169,879484,636389,72526,529161,170686,396291,632168,341599,687709,273871,465489,76767,885852,406446,1046608,694184,107503,661872,426187,369033,1005093,1030621,1047494,65240,33614,690942,247001,175777,904737,64634,148844,1024939) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001024s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 781880 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000325s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 781880 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000418s ]