SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003281s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415773 LIMIT 1 [ RunTime:0.000567s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415773 [ RunTime:0.002358s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (267109,1038588,73261,589401,429556,866317,666656,46879,19818,633467,415120,99391,135876,937253,955531,1029625,645669,853849,155819,301186,943249,166269,630463,171802,319541,255463,638358,669838,195143,173579,501184,169043,967648,597880,917616,961476,418420,152370,49589,864185,259929,989030,420113,280722,547309,165601,692924,84535,85714,517176,836982,688050,408287,598761,866295,1034107,138411,402457,730743,923667) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002428s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415773 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001404s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415773 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001224s ]