SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001071s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 480032 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 480032 [ RunTime:0.001908s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (658321,562603,320090,157024,277021,286584,365478,193436,445919,294235,918912,759247,208474,518443,334308,403524,41353,468222,462619,499372,415352,789972,935864,989459,404102,450830,1021299,105542,242960,278462,559056,293811,388459,924762,913825,212142,888731,427280,760860,347014,201810,780128,1012920,26051,946858,94922,632202,1039996,439033,947318,563499,737100,795398,416315,672482,40011,1036846,287242,953805,180576) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002086s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 480032 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000404s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 480032 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000573s ]