SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 509832 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 509832 [ RunTime:0.005897s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (540273,198047,42913,491800,217900,512364,434222,811300,541987,341518,461181,225275,85831,215175,394936,506106,50601,43186,291047,916441,378601,266497,9915,222528,803101,613235,242528,342109,634532,772925,149455,452728,194223,868091,1035387,681327,421568,34686,441955,1009192,881772,277536,579114,418,483076,1024106,1031325,835432,373685,533398,42924,996417,559394,620500,1035340,717632,640235,790379,795761,1046317) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001293s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 509832 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000430s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 509832 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001474s ]