SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001843s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 198007 LIMIT 1 [ RunTime:0.000504s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 198007 [ RunTime:0.003661s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (401963,170812,984015,541436,546971,839159,526142,884283,467487,54154,83849,255130,608220,803413,63192,120393,898340,1005275,418686,728868,381516,997337,801334,726816,449808,520304,175054,713667,436353,881278,374963,568888,650214,640114,27835,872198,946993,671437,126342,1003246,239093,804026,422966,743929,302087,44979,161071,1006718,836410,498067,231373,833859,524934,890698,212250,609442,975679,570129,580953,504817) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001904s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 198007 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000501s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 198007 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000523s ]