SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 589936 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 589936 [ RunTime:0.001463s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (304869,998094,469164,80404,171968,1017725,131407,809793,170434,26384,308993,888835,570652,786768,609268,1005778,891210,492070,5373,701979,201995,248476,826170,991468,444206,215471,338446,666052,27353,434763,379905,774380,350500,317262,888293,411408,170989,40575,254893,205774,847879,127795,618275,361466,518013,1006286,60657,884336,376415,734184,182179,220398,574277,1016731,877929,10298,311530,1040475,282017,790181) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001269s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 589936 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000445s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 589936 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000546s ]