SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001101s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 105245 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 105245 [ RunTime:0.001688s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (708843,38929,227213,447008,782079,662570,65349,729155,764089,623440,970666,945868,471360,831971,397467,609290,498647,504864,675211,627377,101741,36847,1036018,2184,334252,878947,396,5992,540958,881196,1020368,482379,742895,21130,262414,651641,566419,540168,603743,981002,996529,1017384,661096,741439,835825,1022825,79187,489770,475327,34603,675281,700758,423835,661048,353170,1040160,137479,504000,38248,67012) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.013920s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 105245 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000490s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 105245 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000972s ]