SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 533446 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 533446 [ RunTime:0.002893s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (199586,358251,266404,435432,578565,554340,39370,533271,826637,945804,96898,823038,249628,537267,223644,976473,759351,23328,120368,656945,385592,997177,512027,87645,761037,1045185,753569,872520,1039885,165721,54940,729943,848728,648009,928287,577186,867563,169494,489358,763597,826207,534296,623579,471442,408171,258900,308441,202117,267406,856784,593576,837762,483210,451118,460541,885812,463226,447058,411707,311740) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001262s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 533446 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000553s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 533446 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]