SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502177 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502177 [ RunTime:0.002035s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (411223,972447,8674,5050,943960,609863,844799,523256,995393,734845,219682,213670,183337,507887,889480,471999,984951,119885,5008,594633,129736,521086,1003050,582090,738006,777078,1048506,45687,914306,430491,456905,560805,48667,332446,302846,381438,921045,997520,714503,944271,735380,992300,280503,302468,315705,15447,960656,11308,387177,662558,833147,585939,511960,943993,579115,393223,934537,697012,139154,142979) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001061s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502177 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502177 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000994s ]