SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001260s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 40487 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 40487 [ RunTime:0.002435s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (177411,921066,307010,928911,203697,87176,1001641,154413,670390,870382,284674,993051,796050,1005205,727997,180554,391640,1007603,968517,430529,525554,464959,405806,681894,943767,1032459,118469,996931,632640,643574,445605,298626,1019757,803207,651514,418557,555309,491102,311810,319721,53448,494588,589267,622759,660040,32136,734179,841724,364912,325081,168266,601416,139057,945289,5217,894245,428774,527413,815154,944492) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001073s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 40487 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 40487 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000525s ]