SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 280258 LIMIT 1 [ RunTime:0.000394s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 280258 [ RunTime:0.003137s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (814542,793613,801419,919290,398821,881969,229305,774574,205441,466231,844434,208582,812161,298776,666405,716546,379185,227531,443319,383867,1033482,887046,32420,785025,653800,804349,440824,258304,859092,455721,272880,166468,187955,66381,627076,256887,285382,924995,788652,289107,781910,721010,314132,425526,17805,191093,375544,4868,494592,198976,621562,574429,115379,752701,13785,21239,858600,27922,597513,267353) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001066s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 280258 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 280258 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000535s ]