SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 526439 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 526439 [ RunTime:0.001701s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1042866,257095,912421,473731,689538,220469,487290,861680,174619,224183,379006,277712,643848,21909,386739,513474,13623,631202,911227,707592,541346,230540,438932,228651,745578,860110,387497,98714,269797,192378,250440,643369,365328,1018499,1005451,169181,618158,751332,874981,559259,429959,474369,847824,646130,813000,128955,1014853,108026,74621,1016663,808277,30694,238461,992637,959540,757681,349389,394861,339515,540139) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001018s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 526439 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 526439 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000571s ]