SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002007s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 396520 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 396520 [ RunTime:0.003595s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1008902,560644,1014962,924025,605002,542448,747846,183403,858770,260935,15711,600780,466415,961671,978672,393003,699518,766970,882875,70296,975948,337304,1026182,586926,856139,218496,224148,794790,921137,632596,468924,401552,955286,802316,613605,228500,818743,90691,575578,497154,749043,545673,689429,1044679,679191,365760,261270,387159,565020,120712,521887,567827,997151,902348,104454,402448,388497,165043,598407,91291) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002283s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 396520 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000411s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 396520 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000696s ]