SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 417374 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 417374 [ RunTime:0.003065s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (447987,452099,241261,1029286,200978,970341,511622,281917,5776,914288,970408,501709,971000,1253,4150,306484,271907,385295,1034631,646203,174796,62386,286191,440144,426321,523150,336614,37727,295047,323090,294438,428169,81432,178355,805276,971195,824287,1015935,1039809,994175,507975,665984,831691,13323,735346,378139,525186,362371,192164,965311,690875,110176,328138,641888,961528,761770,452543,244506,534513,537005) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002959s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 417374 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000500s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 417374 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000566s ]