SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 793580 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 793580 [ RunTime:0.002106s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (445188,384303,42158,496250,255959,1002651,781802,308577,678146,374082,821502,156984,320257,457080,685464,689891,573347,588112,131513,343837,343364,502667,165680,723496,379743,105262,321527,689719,1037837,699846,756051,558396,567942,742107,128073,50248,887493,818135,55807,379885,241492,108530,103030,46938,927940,29566,233019,711099,292629,694042,361626,1001160,1033787,204083,101636,318612,890226,30166,1043084,449541) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000953s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 793580 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 793580 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000554s ]