SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001350s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1047206 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1047206 [ RunTime:0.001970s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (953754,178037,560435,94422,424836,511697,471414,870286,985398,317085,187880,758688,468635,278087,527087,635400,670456,363455,167305,763889,79368,807602,689395,165028,973837,702042,718247,265620,742738,70850,374327,205430,640311,786,456239,160569,765612,657716,248834,923349,147018,877359,872636,784060,871052,21443,938224,83869,411200,762358,266370,959581,582657,906303,665630,516262,895949,1044998,683597,50028) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001063s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1047206 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1047206 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000486s ]