SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 53697 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 53697 [ RunTime:0.001504s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (27226,442997,802952,314267,869468,1014512,375427,183214,501880,290115,406535,195945,19859,13019,468127,452708,850880,296974,634745,375073,9201,994628,866998,159480,421323,135559,885717,141274,228518,772220,439597,34259,572951,1037452,536363,152132,302603,710107,108646,276294,765136,805738,308008,407968,938035,149063,14902,672014,279951,797253,301498,277633,316742,612607,532248,749175,826765,209744,201162,869797) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000995s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 53697 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000865s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 53697 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000563s ]