SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001245s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 470412 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 470412 [ RunTime:0.001613s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (621001,795791,752651,387206,341247,37169,913839,118313,501349,662188,338961,442116,625939,675127,662217,1048540,268808,133274,148578,921383,319710,497020,687003,522711,885728,521364,468971,671226,172368,986120,58550,801833,776746,73722,334824,822266,118544,1014143,8464,916762,172064,40239,267579,909797,503113,699470,838099,739971,124133,493049,484885,405541,846217,796098,869143,349807,791907,785249,616715,854110) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001073s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 470412 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000431s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 470412 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000518s ]