SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001271s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 509212 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 509212 [ RunTime:0.002426s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (917032,59110,730431,285700,132061,59241,997614,788382,563113,597400,263938,919594,488736,1039912,373367,1033704,408721,300647,1031900,352543,86702,270669,954009,131928,15137,126994,437892,27662,693677,33696,44762,227349,818456,340205,781971,523828,910704,462820,617982,77825,880321,176713,381991,772735,359697,418768,433061,878394,407051,302128,857817,635889,542422,149380,567382,987314,730271,524034,649184,686972) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001297s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 509212 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000433s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 509212 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000452s ]