SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001445s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 558860 LIMIT 1 [ RunTime:0.000433s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 558860 [ RunTime:0.002587s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (341060,376206,725669,73812,377486,537420,860188,371658,133589,146734,350799,583621,278178,130353,849729,280251,61854,877780,701415,418490,177392,338037,182916,134279,25570,203379,895015,114626,912990,474793,211827,248614,542591,743361,60605,177676,1033900,913222,709060,884078,355786,731985,536680,522394,88548,628174,182038,631390,294699,998260,874950,987172,415940,717372,413588,914969,293090,482902,601057,768024) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 558860 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 558860 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000787s ]