SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 531042 LIMIT 1 [ RunTime:0.000401s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 531042 [ RunTime:0.002128s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (625234,967055,687532,809492,710440,611536,895959,194314,27526,254977,985977,486728,578941,838814,46330,847493,884263,135423,642774,1015917,807147,790138,764352,928956,481196,499082,788774,398243,331642,511619,787091,993644,738137,523617,876565,578648,854513,446822,592695,349446,710003,818955,584310,820077,424037,145011,1022056,900779,948378,20474,494444,106695,986610,16868,444711,150903,898874,148305,1029146,3028) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 531042 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000461s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 531042 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000876s ]