SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001365s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 34107 LIMIT 1 [ RunTime:0.000402s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 34107 [ RunTime:0.002300s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (106688,890152,793550,848903,439255,554687,760157,816824,534054,722325,580834,708669,115511,454786,540326,467907,649185,653302,724377,614360,334222,183614,960537,220448,619112,999232,1039555,942404,85987,112490,896538,84220,1028887,363510,10450,345439,626958,151459,182581,971168,805214,467978,314627,184036,673366,98491,994672,543764,496952,198874,180218,773939,356828,612203,825600,1042714,49204,282866,263025,531660) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001113s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 34107 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000443s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 34107 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000568s ]