SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 534276 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 534276 [ RunTime:0.002545s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1044986,50721,391055,283292,660347,209016,855979,759059,28697,216553,962696,789999,142051,904226,206488,475721,941265,2590,322361,538507,956964,302711,288171,151532,212301,571347,366007,907985,672830,439649,795347,413694,976149,482644,991702,633691,245414,52300,34220,461874,805583,12701,489564,409790,317020,895503,122745,869251,333595,251595,155113,372943,397908,362581,556614,70529,654154,738271,229570,320687) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001466s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 534276 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000552s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 534276 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000577s ]