SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001264s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 328156 LIMIT 1 [ RunTime:0.000430s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 328156 [ RunTime:0.002684s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (393536,978027,526933,1016270,28457,803823,345639,1034003,927603,22881,42905,195119,245482,345867,338207,491797,711147,282536,632680,609410,181818,980901,336879,804690,304618,1034714,980936,1024337,891475,577966,410831,556121,563346,789063,380776,583083,197441,363667,22803,333826,895398,897916,482408,599444,393062,866105,409091,309209,788566,45077,565129,146762,52397,754002,1044995,420018,489321,1008558,510407,550223) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001269s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 328156 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 328156 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000619s ]