SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 295410 LIMIT 1 [ RunTime:0.000414s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 295410 [ RunTime:0.002239s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1007138,437550,535373,574786,423862,644204,864734,187656,358575,223541,158302,874289,269212,319800,697607,654919,869662,762163,513439,647081,408010,299397,20780,1019914,341438,507468,522457,816966,69592,866395,652138,283349,98330,762057,886120,450073,869056,920978,154103,833244,260547,30502,811441,39614,461310,382009,562639,840351,771881,83106,451513,654931,438246,1039601,5488,812391,1986,265416,939960,801388) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001090s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 295410 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 295410 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000597s ]