SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1018791 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1018791 [ RunTime:0.001526s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (201211,977606,688486,565182,503751,459345,712221,245668,100167,434556,16707,112544,385496,139663,161131,695414,1030030,170801,312549,484749,836057,248205,322475,929203,426667,379833,311379,284290,172894,68257,249706,290706,314119,543176,748475,264202,384994,646216,889702,799110,10491,406607,419384,751168,321496,965082,190806,630469,844848,737733,615703,10742,615311,862754,40668,871912,195297,769201,932078,367461) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000967s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1018791 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1018791 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000494s ]