SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 33470 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 33470 [ RunTime:0.002480s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (610554,81796,801293,146762,447503,115721,403055,635233,368643,159096,55897,732166,309906,20474,959108,859854,748614,466858,1044582,197984,1038512,76153,675034,603110,327151,873278,422065,324151,491236,338411,61424,106507,271738,122681,574047,392332,43738,579166,1017393,682559,473517,995602,520508,399822,637375,218693,702196,492021,510602,517977,288343,148689,846473,839733,212132,859389,412190,787633,535965,379717) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001296s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 33470 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 33470 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000512s ]