SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001276s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 320616 LIMIT 1 [ RunTime:0.000402s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 320616 [ RunTime:0.001542s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (617549,740442,766146,933245,139275,218762,397495,541633,769007,636641,529289,825410,664784,1039692,44614,303667,95348,857102,710155,1010862,511005,820008,409420,1005025,388471,608485,654423,198641,129645,751728,107816,601324,294789,318562,339980,904709,202965,234894,954456,955112,122780,511467,463461,532476,252338,833593,430916,110692,1045087,654285,792502,129721,428274,1042080,413197,223318,540244,211207,399520,1047644) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000947s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 320616 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000414s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 320616 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000645s ]