SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001183s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 553409 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 553409 [ RunTime:0.001580s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (480022,403001,942712,1023252,348185,948281,920930,303876,227910,645017,237952,152680,615423,358597,60825,905867,58603,1033840,319434,616334,323305,1038634,545429,240034,442122,564053,226077,575248,912794,87309,1032363,592963,364782,392670,743232,784209,910562,286812,273617,146574,935863,87345,961877,18563,554303,188112,872346,133370,359049,63803,61875,23148,502290,299375,201137,374690,915813,990957,230170,525578) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001091s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 553409 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 553409 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000495s ]