SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001118s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1036846 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1036846 [ RunTime:0.001603s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (663776,673731,936126,51511,596326,188299,226738,530253,894785,130427,316850,115370,402283,898033,61076,258844,4966,1005246,412189,543783,106786,792477,496059,657415,979357,1039809,61939,182441,584935,727870,561984,954007,956763,436695,532315,832512,86095,1000478,87339,420425,600239,398918,812321,583789,263197,255091,12656,841681,349976,952057,657804,909498,14418,358818,542016,697734,406234,458250,130365,851264) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000939s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1036846 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000464s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1036846 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000562s ]