SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 531642 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 531642 [ RunTime:0.001697s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (281068,1012240,902640,430025,402293,852317,388361,636062,658666,201880,775069,96667,1017795,361052,176195,1046917,18978,39476,1044365,919997,930075,649701,20010,465772,855412,529874,634964,34206,459116,1036635,580328,558142,780893,981916,726540,196380,858695,115057,431235,294571,642039,486043,977376,617618,1010915,430096,25910,467585,109576,183932,24794,91991,734802,855093,1015157,945918,1032538,355949,861828,569254) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 531642 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000857s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 531642 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000536s ]