SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001228s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 484098 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 484098 [ RunTime:0.002561s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (926371,510356,874811,472583,78407,191844,587979,594081,684644,677081,379169,160711,455462,759134,543046,431588,978835,937909,616604,510626,773123,391853,756032,132868,138503,957519,940100,633364,837161,911816,398057,396399,674695,508992,706306,837936,775784,825355,321556,380072,236141,290799,203497,1017985,914308,322252,931456,185199,851534,347785,65910,543758,690026,373968,152336,462671,761273,960368,1007230,351699) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000995s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 484098 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 484098 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000543s ]