SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001104s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 570520 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 570520 [ RunTime:0.001489s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (112054,482924,1027120,111285,202845,256969,394543,502288,469941,169443,167893,17477,466426,721740,324462,219707,354350,1032655,694601,938761,109597,124310,236175,926317,459553,200280,96257,881594,333344,72466,855598,500109,739478,749227,179620,101160,514539,572659,407508,653123,774554,142619,196615,714766,102774,411044,873550,159019,443737,230665,967394,10045,269500,613204,489917,105468,231886,264978,219733,207639) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001040s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 570520 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 570520 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000416s ]