SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001247s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506535 LIMIT 1 [ RunTime:0.000451s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506535 [ RunTime:0.001536s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (980780,671362,111279,898296,723521,127465,385497,774507,289652,950010,1020444,919997,221382,416562,13036,198113,215117,736324,872004,732811,938865,143987,142980,529321,349839,93934,440503,688843,669144,803582,1001674,469807,257374,640770,896226,1004663,577834,254824,158614,819630,272339,846797,232667,78413,325634,907085,974149,765676,817303,840240,841874,523737,328275,215876,71741,812189,260685,857963,824341,573946) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001034s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506535 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000612s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506535 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000707s ]