SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001528s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 50510 LIMIT 1 [ RunTime:0.000490s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 50510 [ RunTime:0.003680s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (423446,375445,846856,1025879,407449,491771,1016143,868404,281335,705953,679495,926032,261808,318815,613855,876022,167114,216889,284894,265967,748878,607829,236059,559409,319141,352489,297009,544305,923946,866474,1024937,261916,1037065,42727,859731,359142,815934,196979,407886,920163,953175,68995,161747,2012,515506,904177,621785,172668,800258,582039,689831,843860,93717,361571,840633,276673,998813,647636,913847,294272) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001312s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 50510 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000431s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 50510 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000666s ]