SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1023110 LIMIT 1 [ RunTime:0.000458s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1023110 [ RunTime:0.001760s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (668235,658485,23933,9846,239325,852082,30170,496259,494671,607538,126285,831510,686150,314653,523991,940619,1026525,302692,890093,1039197,805285,291476,495369,25935,150045,64293,230104,704620,853305,536265,482862,417256,1035233,123100,991885,5839,137868,1016027,12513,98824,260986,378714,904970,406899,544660,29389,958593,475067,14419,435088,509436,347969,11422,817790,992899,88358,47528,900408,663316,19902) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001323s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1023110 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1023110 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000563s ]