SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001254s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 481713 LIMIT 1 [ RunTime:0.000317s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 481713 [ RunTime:0.001594s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (506262,64531,752862,500165,975421,279762,465857,389508,269438,448060,273067,861142,506906,230882,792705,717847,406401,937624,387328,178261,223697,642185,186519,169829,207047,857892,853758,311229,491789,33490,121727,943792,859950,101842,274713,584179,63519,408106,127955,940871,1048809,49062,468529,63049,285514,828195,619894,301618,243636,457858,407612,501650,538786,690916,674171,958335,88175,404313,471330,867798) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 481713 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 481713 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000551s ]