SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001367s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 194953 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 194953 [ RunTime:0.001775s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (497672,539480,1039351,287456,846350,130961,602218,809986,859585,357678,811927,302706,630337,357421,226925,1030114,480742,858189,364122,158938,351207,759437,184633,782848,952476,437338,91931,47435,444121,205583,1034289,387937,390057,864177,760320,79285,1012897,48489,250762,5455,301832,177056,170484,137803,976716,676304,224281,511007,140867,258350,86235,363478,995538,177379,1028967,665309,359570,299249,802887,460830) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000974s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 194953 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 194953 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000472s ]