SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 91028 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 91028 [ RunTime:0.001917s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (44816,580724,99420,771881,110197,24645,488340,239426,454932,704148,397780,729459,425982,854972,531516,331967,362667,282957,477332,934593,492264,562142,845372,526833,348638,798863,408990,474666,32782,968951,981543,316560,690683,629926,759467,149062,9391,551790,409278,436751,993524,1012322,26966,550212,7754,57747,729666,1006,335058,864260,81213,627472,451202,445804,905574,254890,560791,523444,1031559,325137) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001448s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 91028 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 91028 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000600s ]