SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001300s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 315208 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 315208 [ RunTime:0.001692s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (55284,592138,118003,935975,257449,464349,944318,205400,224202,20017,725228,91221,86624,806788,678235,967549,349206,449728,478969,454970,731234,486675,824898,444881,1005349,552959,133379,802258,252469,646398,833661,382787,140212,6062,286887,732313,481794,371961,583923,410140,365246,899372,825736,897818,399288,376072,740390,259978,870956,802184,513591,842880,695700,34928,760821,801073,80949,411890,937288,1039133) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001081s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 315208 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 315208 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000602s ]