SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001091s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 110187 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 110187 [ RunTime:0.002300s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (743150,173345,1010245,397236,122843,119222,598703,931465,719588,253992,549966,166780,346624,311478,640208,495561,146522,452233,320756,589159,366301,54706,948341,723922,778173,680191,290081,650502,376119,202313,856872,986788,910962,392638,1008115,149925,679586,333735,994879,412054,358549,360339,713301,371554,229991,249988,190923,238082,258362,431202,473002,897924,829812,586935,22517,477066,3583,803281,508312,844392) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001020s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 110187 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000859s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 110187 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000553s ]