SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200344 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200344 [ RunTime:0.001549s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (166190,68158,561112,830243,285954,319875,85352,557294,395327,587580,909965,382455,249657,708002,998972,142027,107110,840658,1023590,952974,220067,158845,193776,174904,30959,211798,215231,453700,878600,958970,408757,489054,388104,916200,674261,470088,924203,58118,182840,327798,479852,417537,870090,549686,980327,270720,453012,436962,729631,487786,673706,322747,926420,271633,963086,272317,35703,881170,165902,371349) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200344 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000472s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200344 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000561s ]