SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 820045 LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 820045 [ RunTime:0.001631s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (343054,88333,49921,910434,224751,1000438,775354,103046,371235,970835,791915,838472,867413,1036853,251345,540801,679032,183884,667466,609913,204533,858034,12435,45316,26946,155415,969958,878528,79313,823615,606730,589177,762891,1046991,145209,409921,454777,663618,1039476,249195,720848,599180,303000,245218,870187,3919,850275,344717,504491,309879,769705,572549,714349,335115,111623,218482,305764,247411,422358,786113) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000979s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 820045 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 820045 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000442s ]