SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001650s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 754008 LIMIT 1 [ RunTime:0.000489s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 754008 [ RunTime:0.003418s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (930542,171976,201118,201544,273722,369463,826042,307140,14191,500487,693892,247643,531050,631088,10730,110918,726647,448046,695454,316994,611228,101671,584390,166844,51025,55453,709289,466900,917801,38671,1007046,250036,1021046,778004,116423,973519,869433,548315,502259,931080,397103,353075,123615,898931,792700,628533,671854,841059,219190,12883,587784,249331,461554,269514,989952,282761,1036647,333983,120206,205039) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001085s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 754008 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 754008 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000732s ]