SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001331s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 702012 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 702012 [ RunTime:0.001973s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (83473,723938,370012,574103,800208,373328,57718,787455,741052,703560,735744,786732,175932,334770,830516,151575,213887,271216,242621,830931,766420,591421,506798,595032,132435,207081,189013,28001,517793,470427,788030,1004184,525012,396212,115574,122761,708549,723539,368648,645529,662192,840753,675968,690285,438688,72482,473248,943410,596349,331440,899746,508705,398099,64428,216915,300543,326652,701375,367835,566095) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003467s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 702012 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000668s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 702012 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001459s ]