SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001205s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 543429 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 543429 [ RunTime:0.001481s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (395331,183914,210201,1014822,296728,262096,544014,1048076,217106,936432,1009357,1005315,1040143,412461,445839,293235,958581,695837,210373,563992,496446,507147,153538,371775,805039,265774,715119,621836,819529,853367,727472,158826,116415,520025,187117,217148,318597,143592,497326,492728,276704,586788,983820,649614,145104,954796,186936,1026117,968930,108570,607164,110668,806457,470135,849506,767892,845871,1020674,33245,288148) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001087s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 543429 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000847s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 543429 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000539s ]