SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001183s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 564876 LIMIT 1 [ RunTime:0.000416s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 564876 [ RunTime:0.002030s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (187514,616111,310531,81027,820764,694884,582003,595391,1045965,293194,867682,321294,22978,309052,540504,391311,93531,743743,776437,540872,497340,835883,497958,703559,768452,801414,189769,1000146,1025085,295952,774151,293291,409410,1042182,862101,1627,680554,479597,357067,907117,36092,149447,303227,521357,462519,72085,297219,70636,469472,641370,233832,334290,47187,163440,851171,689058,606859,242606,142812,132744) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 564876 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000579s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 564876 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000573s ]