SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001124s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 515846 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 515846 [ RunTime:0.003445s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (527296,279395,204009,325598,610072,508285,429936,278831,151268,141882,900706,488973,920813,482593,851823,900419,981839,926683,177238,625180,404706,871220,152936,495275,418555,915687,560173,872961,843058,399827,417818,912595,972659,902657,822614,909686,257649,84777,714694,167086,997628,345291,926864,668340,731890,169477,185262,985527,600082,774335,649130,896263,290627,829008,113485,850521,846872,426854,688003,198514) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000966s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 515846 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 515846 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000740s ]