SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001258s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 839908 LIMIT 1 [ RunTime:0.000413s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 839908 [ RunTime:0.001574s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (53482,996685,999101,879845,332805,284515,217665,399300,955971,252387,829800,715354,516895,873961,463209,17932,100467,715748,823939,8089,579500,424841,873078,230525,688189,1010052,249111,499351,336171,70217,856466,642605,1006779,1000096,135504,411125,319059,58,381358,108133,191988,808922,200013,208531,653283,179390,18288,136909,195164,254837,977833,991821,316062,138943,807556,801025,627841,746223,174587,5931) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001768s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 839908 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002298s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 839908 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000574s ]