SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 41595 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 41595 [ RunTime:0.001790s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (111720,235834,910759,969356,813073,679166,365296,1005788,346753,242681,856883,320130,302256,368264,597018,670521,820249,908230,585231,665792,385169,324670,793394,30693,229765,479425,248015,355267,1047512,597817,44146,860184,981543,335087,5693,810620,404415,804844,527755,599483,510173,988804,74473,84908,937548,151019,834541,560668,727463,885347,542193,867709,440600,867367,25720,902478,725212,338252,858725,310610) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001446s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 41595 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 41595 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000530s ]