SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 424086 LIMIT 1 [ RunTime:0.001099s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 424086 [ RunTime:0.001844s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (638646,142255,356913,281003,445761,37312,178407,576708,563050,825753,312349,783323,386891,334217,669393,888957,212150,238599,953027,4021,440729,134118,411131,158087,917481,646808,425776,101036,911274,176771,352028,165601,310474,416418,517133,595922,1033639,21072,166965,736106,921862,579656,85200,133179,229248,1012590,273043,713131,348709,358050,412868,953272,339410,655417,141294,339034,562691,991461,364799,77730) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.013064s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 424086 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000538s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 424086 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000581s ]