SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 403317 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 403317 [ RunTime:0.001433s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (855943,170637,851482,190274,657314,819484,906716,331406,544787,861350,429151,567665,455490,412221,618397,990546,446347,616469,336745,230960,619184,256710,668075,1045485,206759,531424,201095,144572,764251,151464,757179,278247,896360,273520,718362,930007,950353,554534,206440,1033340,651151,351102,510595,335980,731285,933233,999547,800319,95909,822551,699553,438743,323530,743988,890636,316059,103528,984154,91500,548951) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001014s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 403317 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 403317 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000477s ]