SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001094s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 622983 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 622983 [ RunTime:0.001593s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (890769,728914,753136,936602,101329,253042,283885,297600,250728,377219,677140,368535,838757,1037097,895445,209926,445684,925043,309490,842396,480218,9556,1006221,709142,486326,429986,654058,906911,886358,482009,1003718,483793,1004391,72211,110081,206408,505321,961798,1025889,804995,568199,1031879,26622,905898,499343,487913,89024,27746,849356,664388,101196,414059,229084,450959,476305,558050,260892,943910,483636,1039347) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001041s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 622983 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002126s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 622983 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000514s ]