SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003407s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 231449 LIMIT 1 [ RunTime:0.001080s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 231449 [ RunTime:0.004513s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (347611,684228,206854,517416,136715,4394,397565,384493,404229,331206,638745,401464,217085,226943,200696,701485,743726,738910,568739,976850,339749,116051,892388,1000798,92259,440845,193877,353016,419746,50261,435237,415760,873384,420391,1021,734007,979100,771590,271074,890600,159179,614731,431756,173678,585331,1016688,200865,76572,905684,545144,427229,182121,958434,706919,296798,732615,1020398,809066,114907,805597) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001272s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 231449 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000532s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 231449 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001397s ]