SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001341s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 901192 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 901192 [ RunTime:0.003186s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (802096,601535,572427,409752,329116,79433,40720,232145,260358,870995,740953,527754,179394,829063,102494,823614,1046298,357336,792560,581190,927819,934778,376832,543552,572772,432041,750226,230043,86975,54575,228052,862749,978379,409562,292928,1003122,158432,781635,84710,284803,156086,382379,714640,1031902,244429,1014869,462578,719973,365655,441667,272643,612375,364358,425987,369981,334035,342072,879457,827598,565798) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001680s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 901192 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000565s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 901192 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003157s ]