SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 460523 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 460523 [ RunTime:0.001785s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (389750,906147,518988,496927,517715,217360,254402,926798,1020618,805187,198224,382070,461792,481942,415180,625460,705497,867057,9225,975479,425739,1021646,467728,979983,994568,582922,219384,1022440,883497,517682,241621,281460,616204,748410,509985,870563,678822,504601,673254,728136,219485,745610,973405,1019874,540587,969959,39123,724763,153321,1551,584549,873354,144373,29761,138155,604076,407931,742754,1029274,381371) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001103s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 460523 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 460523 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000677s ]