SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001594s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 519682 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 519682 [ RunTime:0.002119s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (701562,1010471,104002,1043376,347404,534991,77711,719581,565760,991417,978584,497633,901345,242205,689954,138594,767715,643881,47791,1033697,896871,78693,271190,241636,319037,240735,662693,616118,280829,537407,296028,126995,810971,183641,483222,941414,253488,10458,624098,615063,560144,749914,107875,482164,1005491,149337,1020133,508817,1029061,722989,184565,211017,804740,967057,512531,421262,590667,637198,218667,69082) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001274s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 519682 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000669s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 519682 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000578s ]