SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 295458 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 295458 [ RunTime:0.001848s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (915673,404604,199503,400824,505125,367963,869238,1019941,819202,761262,929131,75809,169468,760004,242021,398391,430683,460434,1007770,325696,236425,1010390,363683,550265,208504,797490,609372,28328,390249,735727,597641,681557,439179,546206,306488,599228,7145,846231,923051,749278,270024,808412,912438,957789,765672,620320,597197,152119,707749,345620,303029,532156,407249,402026,151899,988355,314237,915488,332161,479618) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005250s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 295458 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000484s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 295458 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000584s ]