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` = 341142 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 341142 [ RunTime:0.003201s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (253247,37780,895745,588409,893130,804760,357484,881692,721050,178547,952372,964208,414259,224434,753098,514541,1018194,338980,561941,309587,745809,612608,333194,1003324,874139,351407,7415,705805,851512,1042953,681655,200838,993366,49659,356326,263013,462540,1028147,323315,780870,549529,561824,912425,737346,977905,467333,351469,951302,664576,640752,25400,350501,743478,827751,121647,72199,1008755,743087,572288,455067) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001767s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 341142 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001028s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 341142 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000472s ]