SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 301988 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 301988 [ RunTime:0.003015s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (774239,925147,745391,423209,623092,91734,995442,339969,686970,456122,166146,417710,570809,523807,601139,194908,38718,574783,703153,97834,810674,426217,373007,1002870,619443,23213,661106,240464,306208,730628,1043074,135223,352957,680654,790974,871688,346835,728561,866159,504339,322496,705413,311701,747790,877863,432052,166726,764583,241062,881652,347227,171216,793603,301018,634527,981364,499356,960198,153263,1045674) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001030s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 301988 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 301988 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000488s ]