SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 410624 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 410624 [ RunTime:0.002747s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (290490,154121,795827,99211,791674,758275,262824,290051,273070,989578,351933,476976,607278,574639,851064,126733,845758,1025358,600300,640837,859203,522903,811277,956554,421741,495431,621702,674680,694106,40201,517886,1004662,913713,141542,336301,897630,580843,909606,31634,41062,373991,1005702,594520,190515,238089,127058,55027,602045,998755,182508,422807,866751,682482,435426,58624,783804,667313,823936,173145,600618) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005027s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 410624 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000564s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 410624 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000588s ]