SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 562005 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 562005 [ RunTime:0.001478s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (794150,910674,669136,848878,164873,1020916,722641,18749,731,318323,360102,852995,620653,519210,364446,715393,1005398,790812,544205,687567,881283,769648,623692,641912,313042,994066,353358,678212,41012,242252,589666,27071,329967,259376,712738,251557,391464,913756,470715,437103,1045609,411590,271048,712099,3784,32587,992624,948488,64686,246378,1037683,237362,911651,1029936,579488,237772,707140,547428,378653,1004990) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001803s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 562005 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000316s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 562005 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000477s ]