SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 521706 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 521706 [ RunTime:0.001939s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (686372,676563,608778,1034377,32448,796812,466143,463749,891113,681587,344833,1006116,1023052,423076,166277,225145,292015,480739,601261,436634,982698,522753,690026,443983,54113,392299,937750,800381,622866,664102,705372,233394,644239,486387,249735,484235,455871,445819,145620,165089,89550,677415,108352,710675,89272,785110,426493,793282,6807,764942,1041303,922540,50132,888087,325238,813704,1004775,472840,679708,671269) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002122s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 521706 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000831s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 521706 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000438s ]