SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 61998 LIMIT 1 [ RunTime:0.000298s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 61998 [ RunTime:0.005287s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1032719,90954,897889,57118,315240,37582,127540,743224,1017709,528022,988201,585880,663184,626385,774557,997368,526868,406982,340823,953759,39245,136122,494154,130391,848519,328952,803456,416179,1044555,430124,770435,630950,772384,112741,964046,519920,720273,538623,667615,445582,822335,742709,498805,202415,706061,516760,442153,933059,823438,451279,15785,34158,547779,874430,245165,351861,744084,513322,607208,457423) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001104s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 61998 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 61998 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000474s ]