SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001757s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 567020 LIMIT 1 [ RunTime:0.003580s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 567020 [ RunTime:0.001741s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (481987,1036378,942929,392708,391893,458533,799407,311371,758749,123571,507648,529212,276956,361171,615904,514081,737338,24210,475835,804104,223221,211964,97961,415116,743414,272571,58497,714594,444116,921755,719920,645599,1024441,744759,1029354,802852,262074,93699,1026286,912776,413998,235883,162500,129675,304879,1029557,622604,56747,487180,410828,517172,785051,434648,813145,635645,334514,177791,410262,719001,309248) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001090s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 567020 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 567020 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000482s ]