SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1016800 LIMIT 1 [ RunTime:0.001920s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1016800 [ RunTime:0.006210s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (535095,354294,1001587,349410,1041858,28976,175323,13662,848286,923690,1025904,521345,300004,976581,696298,64990,1027973,986853,252133,408617,642561,204938,523508,34133,669855,337502,1013488,724233,559016,434978,924989,422665,104160,582560,740672,171386,518070,150740,137730,819164,1016481,793547,1016661,771271,654198,381980,469490,689517,290094,824078,299823,412629,797045,677681,759225,447694,319733,1041409,494809,342823) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001639s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1016800 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.004733s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1016800 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001803s ]