SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 102238 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 102238 [ RunTime:0.001994s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (727390,677214,239431,972197,912428,14158,804160,338675,316070,983734,327665,987603,224653,429217,983271,843728,996817,1044648,421941,579530,252887,419068,81662,742502,845676,925729,65110,1037552,455687,325636,533310,947283,299042,736921,697981,439920,198640,498945,381079,10801,43590,181,989559,669802,706201,592640,281439,973067,462406,174742,589864,173143,810127,820560,744993,329677,200026,511641,593068,1028587) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001055s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 102238 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 102238 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001697s ]