SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1007543 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1007543 [ RunTime:0.006566s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (725270,111489,995779,260568,758452,11574,265876,369104,469111,709703,486019,181223,555885,738358,190893,957745,333889,855290,838798,1040419,57188,459043,458189,344929,63447,942453,502363,169437,861013,202710,669047,789132,488344,805359,563637,465168,43348,419975,19132,450404,73598,506290,1013538,680982,586016,654049,708686,482612,991464,514860,488604,910055,396732,320478,749329,175838,485903,951481,332410,334077) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001086s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1007543 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000331s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1007543 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001136s ]