SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001263s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 559643 LIMIT 1 [ RunTime:0.000456s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 559643 [ RunTime:0.002596s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (178183,353789,182397,607093,374263,767183,192667,17192,139964,957996,81438,309573,95858,690686,463328,887275,158065,568943,895727,233417,757893,315765,102486,126243,365980,201517,489844,1045018,1035422,223973,633886,301012,515830,697013,895003,10966,824098,523933,579979,50115,594654,928994,663873,53503,617730,258946,768848,148014,71584,457098,621943,71277,895796,473319,195550,575829,179415,237208,860533,526105) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001286s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 559643 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 559643 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001310s ]