SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001272s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 114013 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 114013 [ RunTime:0.002006s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (239032,539447,36881,764919,339680,1805,1008685,1024563,779199,109602,693991,229386,244436,922303,622769,519720,876640,749842,1012550,484002,402017,990652,296024,429400,991230,933422,671593,871995,844629,739268,264112,901365,588944,137754,568864,852654,139913,1021118,620252,450133,292796,701360,659826,435618,912371,523901,653931,284347,450750,426728,974844,752355,589743,313169,584255,933056,889900,95981,952055,198836) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000980s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 114013 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000326s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 114013 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000517s ]