SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001347s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1016927 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1016927 [ RunTime:0.002429s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (548404,440996,243234,43527,214186,325048,655369,660455,480575,953426,103480,752453,896297,18315,435982,1040807,15431,854742,883004,880013,231341,796791,199409,869134,213371,254170,111651,377224,943222,785865,337045,208623,706206,159349,948850,645506,160214,414863,35989,579032,313915,845931,960266,470470,880215,399192,812194,191771,776216,661835,998217,478448,520952,949874,502734,267030,874820,1010380,183321,621532) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001839s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1016927 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000536s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1016927 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000503s ]