SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001245s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200555 LIMIT 1 [ RunTime:0.000389s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200555 [ RunTime:0.002295s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (399390,832450,105071,22131,107464,136741,189651,99460,843046,707863,365604,196486,888617,639599,413338,318583,355283,815564,639845,940651,714635,969492,675374,984242,690614,316971,700907,762947,745257,604140,763114,945358,799213,893216,382553,978788,878744,1015499,888159,686424,773804,76870,534879,326478,876023,864405,612922,934744,627400,558676,410870,380240,581119,613428,10016,620597,1038354,527423,644596,276331) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002137s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200555 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000468s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200555 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000631s ]