SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003640s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 104911 LIMIT 1 [ RunTime:0.001350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 104911 [ RunTime:0.004386s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (695918,591465,38091,571544,484934,389853,909742,814352,813539,426588,47909,385164,449408,280898,494692,964770,815297,911294,712275,353390,1009282,927373,54940,634517,385582,496481,381334,1007131,474275,65428,201029,839096,430682,938812,543522,588895,173939,524644,508493,920462,404461,64588,930826,902388,992504,8389,1011096,587560,108697,409415,451833,295964,818684,759520,735210,954580,881347,822338,576182,169029) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001689s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 104911 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000448s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 104911 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000536s ]