SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001819s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1044234 LIMIT 1 [ RunTime:0.000396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1044234 [ RunTime:0.001573s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (308856,337111,416906,90240,448177,123791,848193,864389,602009,227402,532819,419358,207208,501732,991887,131237,437211,453423,564516,189897,1044865,462265,168341,140350,915367,37092,1010287,1020111,488277,892486,773876,796145,812073,174506,581143,622246,227912,125924,662019,971306,281983,628904,995520,441262,817310,150835,141567,841960,753846,1015244,810362,211623,904536,271281,169160,433065,644874,562830,362017,328518) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1044234 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000541s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1044234 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000629s ]