SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001096s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 461499 LIMIT 1 [ RunTime:0.000300s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 461499 [ RunTime:0.001514s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (949291,642231,502425,25073,62811,658115,644493,744008,638498,564509,742195,459506,613442,235627,226523,426206,951616,902675,952492,559316,771633,422876,247128,547541,807531,47589,360518,850052,98779,247159,249001,719476,392880,446910,106769,930677,826344,761159,411217,755652,202677,600558,437661,9488,581342,331213,118454,120237,105365,337636,253491,413713,394784,313575,826753,624663,1018838,70326,720366,792413) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000947s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 461499 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 461499 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000371s ]