SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 458828 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 458828 [ RunTime:0.002645s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (873314,730135,251406,1020078,327293,892375,421776,584988,38428,662605,463425,503526,831334,478780,662236,145794,364740,276007,413652,839892,86775,897038,631558,982732,888923,242780,422287,884906,850894,989487,1011696,299914,333483,726639,674519,21060,198122,649413,242189,591832,287806,1044311,478916,677475,440187,769268,667756,855622,664017,121123,558623,140838,671763,484988,775361,150124,420005,647363,462357,607077) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 458828 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000320s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 458828 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000474s ]