SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 410159 LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 410159 [ RunTime:0.001874s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (294576,181984,616982,65432,458826,271482,272936,777255,51049,497112,571646,476362,536647,447475,389038,300166,559712,444387,203095,302340,74752,569061,420491,351604,1005297,738560,646068,841767,556612,301734,663816,333564,436771,563322,154012,839933,302103,723231,1017054,428579,218969,153436,602366,571203,94357,865101,40094,855279,741926,316727,991577,80873,477279,612047,377723,443623,63196,868499,505795,440746) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000949s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 410159 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000331s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 410159 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000511s ]