SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 445457 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 445457 [ RunTime:0.001483s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (701596,734138,860096,222887,968988,410399,34032,234427,883119,110409,196854,842182,1011201,508198,329079,941278,913161,228167,541266,967374,693375,411090,932568,4207,40208,140977,117457,714527,950152,810622,404835,186502,20802,442096,922504,981714,572441,377966,284630,279853,918265,502101,984109,70821,687295,140039,483050,335339,967084,393857,269140,570975,287996,571683,251094,807020,629318,24217,482845,209558) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001049s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 445457 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 445457 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000780s ]