SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001302s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 545481 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 545481 [ RunTime:0.001755s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (550705,434200,418522,1044279,745758,585553,70700,426640,785854,188424,811270,403511,494028,812935,808274,537439,100237,558902,982076,695447,952950,775158,1002617,846402,593259,360036,149644,191698,662393,448264,631488,707602,656172,882050,543466,568385,954026,967673,142732,743687,432561,517162,148598,301235,542894,1006052,1001245,470886,632204,651536,196162,161337,67333,832549,633715,1020280,181918,915459,693365,282126) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001037s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 545481 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 545481 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000752s ]