SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 525841 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 525841 [ RunTime:0.002201s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (964146,142053,840782,102213,261256,844899,1034463,110196,101250,294855,140699,539784,1014445,658584,560877,977806,1012794,825855,988527,413698,126480,60782,774715,562498,713081,23364,495502,756936,609478,350383,612438,5672,841333,731749,659319,808039,755915,48477,77248,214042,883344,897695,684641,848360,1005375,226992,183225,202855,256943,598962,796129,397710,885023,819565,353627,69888,910389,369447,465616,311723) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 525841 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000540s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 525841 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000652s ]