SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001367s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1005420 LIMIT 1 [ RunTime:0.001302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1005420 [ RunTime:0.002492s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (278101,822579,520240,1033250,171124,123336,326474,471435,979762,24153,135646,772882,994666,76606,59751,316040,817712,395542,363799,521872,142947,42310,337283,108623,873904,1033551,36866,275045,247724,12364,403091,205376,36891,150272,228853,321811,681400,662582,491078,674755,493482,9488,593353,208065,140378,552412,489859,642743,737598,962515,920455,615063,145591,777815,322128,329781,905765,496600,547499,207398) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001077s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1005420 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1005420 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000635s ]